﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="~/Code/Query Incident.aspx.cs" Inherits="Query_Incident" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .style1
        {
        }
        .style2
        {
            width: 143px;
        }
        </style>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <div style="text-align:center">DMS Administrator Page<br />
        </div>
        <div>

            aaaa<br />
            <br />
            <table style="width: 100%;">
                <tr>
                    <td class="style1">
                        &nbsp;
                        Insert an Incident ID</td>
                    <td class="style2">
                        &nbsp;
                        <asp:TextBox ID="inputIncidentID" runat="server"></asp:TextBox>
                    </td>
                    <td>
                        &nbsp;
                        <asp:Button ID="searchIncidentIDButton" runat="server" 
                            onclick="searchIncidentIDButton_Click" Text="Search, if you dare..." />
                    </td>
                </tr>
                <tr>
                    <td class="style1">
                        &nbsp;</td>
                    <td class="style2">
                        &nbsp;</td>
                    <td>
                        &nbsp;</td>
                </tr>
                <tr>
                    <td class="style1" colspan="3">
                        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
                            AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Incident_ID" 
                            DataSourceID="AccessDataSource_allIncidents" Width="100%" 
                            onselectedindexchanged="GridView1_SelectedIndexChanged">
                            <Columns>
                                <asp:BoundField DataField="Incident_ID" HeaderText="Incident_ID" 
                                    InsertVisible="False" ReadOnly="True" SortExpression="Incident_ID" />
                                <asp:BoundField DataField="User_ID" HeaderText="User_ID" 
                                    SortExpression="User_ID" />
                                <asp:BoundField DataField="Description" HeaderText="Description" 
                                    SortExpression="Description" />
                                <asp:BoundField DataField="Type" HeaderText="Type" 
                                    SortExpression="Type" />
                                <asp:BoundField DataField="Landmark" HeaderText="Landmark" 
                                    SortExpression="Landmark" />
                                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                                <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
                                <asp:BoundField DataField="Status" HeaderText="Status" 
                                    SortExpression="Status" />
                                <asp:BoundField DataField="Date Reported" HeaderText="Date Reported" 
                                    SortExpression="Date Reported" />
                                <asp:BoundField DataField="Date Resolved" HeaderText="Date Resolved" 
                                    SortExpression="Date Resolved" />
                            </Columns>
                        </asp:GridView>
                    </td>
                </tr>
            </table>

            <asp:AccessDataSource ID="AccessDataSource_allIncidents" runat="server" 
                DataFile="~/App_Data/Database.accdb" 
                SelectCommand="SELECT * FROM [Incidents]" 
            >
            </asp:AccessDataSource>
            <br />
            <br />
            <br />
            <br />
            <br />
            <br />

            <br />
        </div>
    </div>
    </form>
</body>
</html>
